<!DOCTYPE HTML>
<html lang="en">
<head>
<title>Source code</title>
<link rel="stylesheet" type="text/css" href="../../../../../stylesheet.css" title="Style">
</head>
<body>
<main role="main">
<div class="sourceContainer">
<pre><span class="sourceLineNo">001</span><a id="line.1">/*</a>
<span class="sourceLineNo">002</span><a id="line.2"> * Licensed to the Apache Software Foundation (ASF) under one or more</a>
<span class="sourceLineNo">003</span><a id="line.3"> * contributor license agreements.  See the NOTICE file distributed with</a>
<span class="sourceLineNo">004</span><a id="line.4"> * this work for additional information regarding copyright ownership.</a>
<span class="sourceLineNo">005</span><a id="line.5"> * The ASF licenses this file to You under the Apache License, Version 2.0</a>
<span class="sourceLineNo">006</span><a id="line.6"> * (the "License"); you may not use this file except in compliance with</a>
<span class="sourceLineNo">007</span><a id="line.7"> * the License.  You may obtain a copy of the License at</a>
<span class="sourceLineNo">008</span><a id="line.8"> *</a>
<span class="sourceLineNo">009</span><a id="line.9"> *      http://www.apache.org/licenses/LICENSE-2.0</a>
<span class="sourceLineNo">010</span><a id="line.10"> *</a>
<span class="sourceLineNo">011</span><a id="line.11"> * Unless required by applicable law or agreed to in writing, software</a>
<span class="sourceLineNo">012</span><a id="line.12"> * distributed under the License is distributed on an "AS IS" BASIS,</a>
<span class="sourceLineNo">013</span><a id="line.13"> * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.</a>
<span class="sourceLineNo">014</span><a id="line.14"> * See the License for the specific language governing permissions and</a>
<span class="sourceLineNo">015</span><a id="line.15"> * limitations under the License.</a>
<span class="sourceLineNo">016</span><a id="line.16"> */</a>
<span class="sourceLineNo">017</span><a id="line.17">package org.apache.commons.dbutils;</a>
<span class="sourceLineNo">018</span><a id="line.18"></a>
<span class="sourceLineNo">019</span><a id="line.19"></a>
<span class="sourceLineNo">020</span><a id="line.20">import java.beans.PropertyDescriptor;</a>
<span class="sourceLineNo">021</span><a id="line.21">import java.sql.ResultSetMetaData;</a>
<span class="sourceLineNo">022</span><a id="line.22">import java.sql.SQLException;</a>
<span class="sourceLineNo">023</span><a id="line.23">import java.util.Arrays;</a>
<span class="sourceLineNo">024</span><a id="line.24"></a>
<span class="sourceLineNo">025</span><a id="line.25"></a>
<span class="sourceLineNo">026</span><a id="line.26">/**</a>
<span class="sourceLineNo">027</span><a id="line.27"> * Provides generous name matching (e.g. underscore-aware) from DB</a>
<span class="sourceLineNo">028</span><a id="line.28"> * columns to Java Bean properties.</a>
<span class="sourceLineNo">029</span><a id="line.29"> *</a>
<span class="sourceLineNo">030</span><a id="line.30"> * @since 1.6</a>
<span class="sourceLineNo">031</span><a id="line.31"> */</a>
<span class="sourceLineNo">032</span><a id="line.32">public class GenerousBeanProcessor extends BeanProcessor {</a>
<span class="sourceLineNo">033</span><a id="line.33"></a>
<span class="sourceLineNo">034</span><a id="line.34">    /**</a>
<span class="sourceLineNo">035</span><a id="line.35">     * Default constructor.</a>
<span class="sourceLineNo">036</span><a id="line.36">     */</a>
<span class="sourceLineNo">037</span><a id="line.37">    public GenerousBeanProcessor() {</a>
<span class="sourceLineNo">038</span><a id="line.38">        super();</a>
<span class="sourceLineNo">039</span><a id="line.39">    }</a>
<span class="sourceLineNo">040</span><a id="line.40"></a>
<span class="sourceLineNo">041</span><a id="line.41">    @Override</a>
<span class="sourceLineNo">042</span><a id="line.42">    protected int[] mapColumnsToProperties(final ResultSetMetaData rsmd,</a>
<span class="sourceLineNo">043</span><a id="line.43">            final PropertyDescriptor[] props) throws SQLException {</a>
<span class="sourceLineNo">044</span><a id="line.44"></a>
<span class="sourceLineNo">045</span><a id="line.45">        final int cols = rsmd.getColumnCount();</a>
<span class="sourceLineNo">046</span><a id="line.46">        final int[] columnToProperty = new int[cols + 1];</a>
<span class="sourceLineNo">047</span><a id="line.47">        Arrays.fill(columnToProperty, PROPERTY_NOT_FOUND);</a>
<span class="sourceLineNo">048</span><a id="line.48"></a>
<span class="sourceLineNo">049</span><a id="line.49">        for (int col = 1; col &lt;= cols; col++) {</a>
<span class="sourceLineNo">050</span><a id="line.50">            String columnName = rsmd.getColumnLabel(col);</a>
<span class="sourceLineNo">051</span><a id="line.51"></a>
<span class="sourceLineNo">052</span><a id="line.52">            if (null == columnName || 0 == columnName.length()) {</a>
<span class="sourceLineNo">053</span><a id="line.53">                columnName = rsmd.getColumnName(col);</a>
<span class="sourceLineNo">054</span><a id="line.54">            }</a>
<span class="sourceLineNo">055</span><a id="line.55"></a>
<span class="sourceLineNo">056</span><a id="line.56">            final String generousColumnName = columnName.replace("_", "");</a>
<span class="sourceLineNo">057</span><a id="line.57"></a>
<span class="sourceLineNo">058</span><a id="line.58">            for (int i = 0; i &lt; props.length; i++) {</a>
<span class="sourceLineNo">059</span><a id="line.59">                final String propName = props[i].getName();</a>
<span class="sourceLineNo">060</span><a id="line.60"></a>
<span class="sourceLineNo">061</span><a id="line.61">                // see if either the column name, or the generous one matches</a>
<span class="sourceLineNo">062</span><a id="line.62">                if (columnName.equalsIgnoreCase(propName) ||</a>
<span class="sourceLineNo">063</span><a id="line.63">                        generousColumnName.equalsIgnoreCase(propName)) {</a>
<span class="sourceLineNo">064</span><a id="line.64">                    columnToProperty[col] = i;</a>
<span class="sourceLineNo">065</span><a id="line.65">                    break;</a>
<span class="sourceLineNo">066</span><a id="line.66">                }</a>
<span class="sourceLineNo">067</span><a id="line.67">            }</a>
<span class="sourceLineNo">068</span><a id="line.68">        }</a>
<span class="sourceLineNo">069</span><a id="line.69"></a>
<span class="sourceLineNo">070</span><a id="line.70">        return columnToProperty;</a>
<span class="sourceLineNo">071</span><a id="line.71">    }</a>
<span class="sourceLineNo">072</span><a id="line.72"></a>
<span class="sourceLineNo">073</span><a id="line.73">}</a>




























































</pre>
</div>
</main>
</body>
</html>
